Tabela Patient

Definicja tabeli Patient

Name

Patient

Code

Patient

Comment

 


Lista kolumn tabeli Patient

Name

Code

PatientID

PatientID

PatientTypeID

PatientTypeID

ChildNo

ChildNo

DOB

DOB

FirstName

FirstName

FirstName2

FirstName2

ID

ID

LastName

LastName

MaidenName

MaidenName

Sex

Sex

NationalNo4UePatient

NationalNo4UePatient

OtherIdentityCardName

OtherIdentityCardName


Kolumna PatientID tabeli Patient

Definicja kolumny PatientID tabeli Patient

Name

PatientID

Code

PatientID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PatientTypeID tabeli Patient

Definicja kolumny PatientTypeID tabeli Patient

Name

PatientTypeID

Code

PatientTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ChildNo tabeli Patient

Definicja kolumny ChildNo tabeli Patient

Name

ChildNo

Code

ChildNo

Data Type

CHAR(1)

Mandatory

No

Comment

 


Kolumna DOB tabeli Patient

Definicja kolumny DOB tabeli Patient

Name

DOB

Code

DOB

Data Type

DATE

Mandatory

No

Comment

 


Kolumna FirstName tabeli Patient

Definicja kolumny FirstName tabeli Patient

Name

FirstName

Code

FirstName

Data Type

VARCHAR2(30)

Mandatory

No

Comment

 


Kolumna FirstName2 tabeli Patient

Definicja kolumny FirstName2 tabeli Patient

Name

FirstName2

Code

FirstName2

Data Type

VARCHAR2(30)

Mandatory

No

Comment

 


Kolumna ID tabeli Patient

Definicja kolumny ID tabeli Patient

Name

ID

Code

ID

Data Type

VARCHAR2(30)

Mandatory

No

Comment

 


Kolumna LastName tabeli Patient

Definicja kolumny LastName tabeli Patient

Name

LastName

Code

LastName

Data Type

VARCHAR2(60)

Mandatory

No

Comment

 


Kolumna MaidenName tabeli Patient

Definicja kolumny MaidenName tabeli Patient

Name

MaidenName

Code

MaidenName

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna Sex tabeli Patient

Definicja kolumny Sex tabeli Patient

Name

Sex

Code

Sex

Data Type

VARCHAR2(1)

Mandatory

No

Comment

 


Kolumna NationalNo4UePatient tabeli Patient

Definicja kolumny NationalNo4UePatient tabeli Patient

Name

NationalNo4UePatient

Code

NationalNo4UePatient

Data Type

VARCHAR2(11)

Mandatory

No

Comment

Pesel pacjenta posiadajacego uprawnienie do swiadczen na podstawie przepisów o koordynacji


Kolumna OtherIdentityCardName tabeli Patient

Definicja kolumny OtherIdentityCardName tabeli Patient

Name

OtherIdentityCardName

Code

OtherIdentityCardName

Data Type

VARCHAR2(100)

Mandatory

No

Comment

 


Lista kluczy tabeli Patient

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Patient

Definicja klucza Identifier_1 tabeli Patient

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment